﻿USE lsk
go


----ADD Columns for AW_Picture
ALTER TABLE [dbo].[AW_Picture] ADD
[pictureURL] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PhotoId] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MediumUrl] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SmallUrl] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LargeUrl] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

-----ADD Column for AW_Staff
ALTER TABLE [dbo].[AW_Staff] ADD
[pictureURL] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PhotoId] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MediumUrl] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SmallUrl] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LargeUrl] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

